UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ym0IeYgzlacxctDZLjp9pb3thNcmSzRxSV9u8bktw28='
WHERE
key_id = '3966963bf7406c0e0261ac914f2c2a9ef6da3386e768c95565bcc5c8f2440958'
AND (
token = 'ym0IeYgzlacxctDZLjp9pb3thNcmSzRxSV9u8bktw28='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)