UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Qx61uDjiIDnFxy/SRV/yBDFR0fRG6UM10VewlqLnvBU='
WHERE
key_id = 'f8ca86e0c1cc2017b40d890f4993df6578ca8bcd0c7a1c5588148a169917a7a5'
AND (
token = 'Qx61uDjiIDnFxy/SRV/yBDFR0fRG6UM10VewlqLnvBU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)