UPDATE
q_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oRaHibHNeFmfV585veDeDk3cWcetZd7e5RMNyGH9wyw='
WHERE
key_id = '471d9409f8907b4440e09c65e24a8fa0b78f8aecad3c28f785d58eb5c4ccacab'
AND (
token = 'oRaHibHNeFmfV585veDeDk3cWcetZd7e5RMNyGH9wyw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)