UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qlDMwUfMrHbnhuphNBFrkMR6ZbOsMyv8ErNRTX18Z3c='
WHERE
key_id = '2f8c9c81d5e2e369bcf6ae321d70fcb45856372a38c31a4d2db9034ab33edc66'
AND (
token = 'qlDMwUfMrHbnhuphNBFrkMR6ZbOsMyv8ErNRTX18Z3c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)