UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yuAc+fSRycZ109uQE+HrZiY3vskoiVu/BU388Vg9kyY='
WHERE
key_id = '194ea36f7fc8ac429563e4a467b83ea112da037a78c5ee363b1584fb9f0df19a'
AND (
token = 'yuAc+fSRycZ109uQE+HrZiY3vskoiVu/BU388Vg9kyY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)