UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EtyWR8vcmQjdEIUFQAKly0x57kgfo7Q5KuBpw6qSf4o='
WHERE
key_id = '0536d01abc2864d03f0f8f9d98b8dffcf9fcd5cfbcfe553cb46791794aacb3c5'
AND (
token = 'EtyWR8vcmQjdEIUFQAKly0x57kgfo7Q5KuBpw6qSf4o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)