UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OT6SUX4sJX1j+0p7/O6SOZo74mnlYWJgPVujuNVMgcE='
WHERE
key_id = 'cd0e761b826a3617529be92d049124bbd81d89ad427de151a342212a3344d075'
AND (
token = 'OT6SUX4sJX1j+0p7/O6SOZo74mnlYWJgPVujuNVMgcE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)