UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'deFJ3yg/gIfqbrtKePoYmKW7/Tk0OSIT7LR/egVQQNY='
WHERE
key_id = '9abdcdc67121803ab14b52df3de57d3028be676d063335db6408a9009d619a09'
AND (
token = 'deFJ3yg/gIfqbrtKePoYmKW7/Tk0OSIT7LR/egVQQNY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)