UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kt1CKyR1BfismtBSoN4jIfyMZpTpqYb3Y9zyxVruZMY='
WHERE
key_id = '1aabbb41c36a7b82bfba4244c2121e0c91227ef4aaae111f3f19f3089a9716a1'
AND (
token = 'kt1CKyR1BfismtBSoN4jIfyMZpTpqYb3Y9zyxVruZMY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)