UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tQKCSO3m3DPZ3gc5HeB6bk3dfxiC27R+2/Lfl3JteFw='
WHERE
key_id = 'fea29bf81318581225193aa043d351fde242013af2d555375655f3169e1dd8c0'
AND (
token = 'tQKCSO3m3DPZ3gc5HeB6bk3dfxiC27R+2/Lfl3JteFw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)