UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9W1uBq+PJHpyFIzU7QaieNP3mzp58+EmmkRD8QUsIfM='
WHERE
key_id = '23f3d6b4931f97de1ee2dbefd2990095499ce118a664ce72ca7e5e5e2e20d187'
AND (
token = '9W1uBq+PJHpyFIzU7QaieNP3mzp58+EmmkRD8QUsIfM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)