UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tBuRdlIHwH2IQTOoCQjkggEYVyoxie2qEEYfOrd+khY='
WHERE
key_id = '5b40bb3e488b301f8198ac17206773bbe1af88a27803bea8359e78820439ff12'
AND (
token = 'tBuRdlIHwH2IQTOoCQjkggEYVyoxie2qEEYfOrd+khY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)