UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KY1H1+lA80mEAnMHFR/hr2te/jVMGZrSh84d1M8VPHI='
WHERE
key_id = '97f97a53523b29bbb2865e6c1114edb6c65248494fa4eb874610cf196b16765b'
AND (
token = 'KY1H1+lA80mEAnMHFR/hr2te/jVMGZrSh84d1M8VPHI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)