UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YGy9gWMISG+tktRuaN+671x2aB9pGyMttyhySU7t9S0='
WHERE
key_id = '328cf846b8b749819beea0a4fcb444dc8e950271a625780411ca5f760cd2a5eb'
AND (
token = 'YGy9gWMISG+tktRuaN+671x2aB9pGyMttyhySU7t9S0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)