UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BX2yy771jnU4CRTllEWOqy7h/pigIQnaCl8c3bl/kDU='
WHERE
key_id = '97f030d488e317d126b83f724acf660c3a862692b96ed1c0486cbff814f6199a'
AND (
token = 'BX2yy771jnU4CRTllEWOqy7h/pigIQnaCl8c3bl/kDU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)