UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VRmrd1UIJyACfBjBkzly6YYjDjS7n39tHjuqRhJ/WjI='
WHERE
key_id = '378dc7b59eb6e0d6cfafb860dd7b1477727f935a65c5d99b999240c441697310'
AND (
token = 'VRmrd1UIJyACfBjBkzly6YYjDjS7n39tHjuqRhJ/WjI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)