UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ba2+5kAHKgjMOpE21T+jJnwA9w3vIkY+4CObkZo33q4='
WHERE
key_id = 'a71deffb1c142547b721fa9a235e5c4fb78c23084733e566809f5d0438cf705e'
AND (
token = 'ba2+5kAHKgjMOpE21T+jJnwA9w3vIkY+4CObkZo33q4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)