UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hwXv1YLioyFpyG9DADTnzwOQ0lMBzKaNf111i+9fLA4='
WHERE
key_id = 'ae7ce626e36ba4e979f909f17b1f2655322c9e186756d772759a81f7b4c427c7'
AND (
token = 'hwXv1YLioyFpyG9DADTnzwOQ0lMBzKaNf111i+9fLA4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)