UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YPPps7T8hgV51gYkD19QIK70d49BrpslDbZRi7fy7Jw='
WHERE
key_id = 'b8c193866d6ce44b9b39444ef84cecb7e99e175d3ab98722ad71792f25c0c03e'
AND (
token = 'YPPps7T8hgV51gYkD19QIK70d49BrpslDbZRi7fy7Jw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)