UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LnXz77CMlDfkM0BXDy0b4cz959EwW34wpVWj4A13evc='
WHERE
key_id = '800c275f79279dbcae380d09302112b2ed73683bb72577a9a9e3adc2ad8b6fd4'
AND (
token = 'LnXz77CMlDfkM0BXDy0b4cz959EwW34wpVWj4A13evc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)