UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'M8gRT0oe6LNOa7JBiXjz8WvaEZ383I9xZFXiViadotM='
WHERE
key_id = '42ce70dae21fd84b996af7230655f02e3149c5984ceeee768af81e80a8f0e64f'
AND (
token = 'M8gRT0oe6LNOa7JBiXjz8WvaEZ383I9xZFXiViadotM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)