UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LQ7hgwVw5SITlXHw0S0d1pvPt7rDw8oPbk4fxk0iQbM='
WHERE
key_id = 'f7cdb93f52dd2fb46f35dd0d6c19d1cb34d6ed74cbf07e5eca581545ed918388'
AND (
token = 'LQ7hgwVw5SITlXHw0S0d1pvPt7rDw8oPbk4fxk0iQbM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)