UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd2foOidGWRAx0/To20VliAerizWFdeqj87pU73uFtvA='
WHERE
key_id = 'a640e949c7afecf43e3abdb1c58fa542654ce132f2c7d4cf014b6c7af596afab'
AND (
token = 'd2foOidGWRAx0/To20VliAerizWFdeqj87pU73uFtvA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)