UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9PKJV1HrcX9JkiWnO6mE5ZoLKAKRjSSHMV2BIchFZGc='
WHERE
key_id = '24abccc1f09303c1b8645df1000673561c0a68dccc49efcb56548badd69fd24c'
AND (
token = '9PKJV1HrcX9JkiWnO6mE5ZoLKAKRjSSHMV2BIchFZGc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)