UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JBDDYKnv/SE31wGGifNCtLqA6okA+X8Fcvbl3S6lWQ0='
WHERE
key_id = 'b53a8d36a125283d2fb11ccb9ad3f59cd38397468326e62fc1b09f21700ba4de'
AND (
token = 'JBDDYKnv/SE31wGGifNCtLqA6okA+X8Fcvbl3S6lWQ0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)