UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dCKV2h17YDaH4M3ARmJimIBU4g1gt/Sk2/RP4+lDZ90='
WHERE
key_id = 'c0295322e8885b8e50dcba95930968e8cc7f4a6cebd98ebc616df173b80eee79'
AND (
token = 'dCKV2h17YDaH4M3ARmJimIBU4g1gt/Sk2/RP4+lDZ90='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)