UPDATE
q_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hKsi4h6oXp1qgp8psrfpVW8mjDj2Kgi61QYsjRNPeYY='
WHERE
key_id = 'a00248e6cb49b4aa7e82d6315b19a6a6342bb5b548afd4d46676a03cf6e02b9b'
AND (
token = 'hKsi4h6oXp1qgp8psrfpVW8mjDj2Kgi61QYsjRNPeYY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)