UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '27dTTQNCvIHcZWECV182M5vH0rJLd/A2ycPArepxJEM='
WHERE
key_id = '9636670bda2954ed6f8c8dec392f997de6963d3aefbb58dedd5a403896478ca5'
AND (
token = '27dTTQNCvIHcZWECV182M5vH0rJLd/A2ycPArepxJEM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)