UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hG0pJV8GSiwxPFjtKl9k46k+wW8/BycxIyCAfdESfbw='
WHERE
key_id = '506beba367a81ea2328b8bfdda1f2034e397e6684f012f705be39c3807ce1dc0'
AND (
token = 'hG0pJV8GSiwxPFjtKl9k46k+wW8/BycxIyCAfdESfbw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)