UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0oFVvFldI8ATxPISLzc3/Ks4wGUoCLwUCNNMN0jn250='
WHERE
key_id = '5c7f0b0fc3a0dd57d4ca526ee6cd6df1df89e43f0e52ecc72fd794de804bd875'
AND (
token = '0oFVvFldI8ATxPISLzc3/Ks4wGUoCLwUCNNMN0jn250='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)