UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ubH6ZAH/qUSA/EJ1HTXXPhCFABKCbp3VxR4sba3R3gw='
WHERE
key_id = 'bb9c62aae778cbeda1b7534ba0a1bea8f651f59ebd09cb59c78bbcb353592f15'
AND (
token = 'ubH6ZAH/qUSA/EJ1HTXXPhCFABKCbp3VxR4sba3R3gw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)