UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CZuQD7OPgClazSRzPZqbDRdzuTOW3P6XyWwkC5m1WUU='
WHERE
key_id = '0e9eaf6538b6f2dc1a81ad9276856a3d5ed2b250746811048e67221b7b857c65'
AND (
token = 'CZuQD7OPgClazSRzPZqbDRdzuTOW3P6XyWwkC5m1WUU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)