UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2SCavC9mjrQJF94JEeRwrk82LCAu/3Nd5Pd3LbqcGCE='
WHERE
key_id = '273a1a5926b3907a37ce6642d82c1372b12047a9a747b0cd79fa0f9c5747a775'
AND (
token = '2SCavC9mjrQJF94JEeRwrk82LCAu/3Nd5Pd3LbqcGCE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)