UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k+lgInlCms81gfZuIfLVQHEHFLGbzBa5Ncu6XjZW5R4='
WHERE
key_id = 'f7a3b530475cc5256bf2041b499405614f59229e711a27aeb83ede414fe3f5b5'
AND (
token = 'k+lgInlCms81gfZuIfLVQHEHFLGbzBa5Ncu6XjZW5R4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)