UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'A1wsVNrv/3ZwOfxJg5OCyrFwEqELk4NZCufln7Sv/rM='
WHERE
key_id = 'b04d22f7d443ce3982ed8de7adc6599b77a84825461529db57cd3ddb2f57395a'
AND (
token = 'A1wsVNrv/3ZwOfxJg5OCyrFwEqELk4NZCufln7Sv/rM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)