UPDATE
q_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zn8vP9VojXv/y/OY5tF/ovhudlL31hBrihSjhvKEdhk='
WHERE
key_id = 'f29e6568055d5e9a59f5203a7bee6a33e07ff3e1efa244e85b7ee9378f7cffae'
AND (
token = 'Zn8vP9VojXv/y/OY5tF/ovhudlL31hBrihSjhvKEdhk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)