UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x24A9vSm/0jHIyXCky/noSmIDyMb8+X24UpTLzWoYeI='
WHERE
key_id = 'd9c70b5eeec4ea5bf5925b6b5a7e39d74eb2389c14e4a2027b29e6aea796ec35'
AND (
token = 'x24A9vSm/0jHIyXCky/noSmIDyMb8+X24UpTLzWoYeI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)