UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OPGtDe4aOL97+3Q+hZBzWsld/adltez7HsbjAsDRHyQ='
WHERE
key_id = 'b0a35190a32a65a5aa1fa8a65124bdf63f33f8a2e199c6597e2b2c0139cb9f8a'
AND (
token = 'OPGtDe4aOL97+3Q+hZBzWsld/adltez7HsbjAsDRHyQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)