UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dyfcBvPrfu4ImTSPujc1hvS2y96kA35A+cBb1Ua+csc='
WHERE
key_id = 'abf99c2b9e091f7971b5d12c6715d948c1516b3244f7756c0b31dc9028956378'
AND (
token = 'dyfcBvPrfu4ImTSPujc1hvS2y96kA35A+cBb1Ua+csc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)