UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iMv92wDf6SAMZ62WC7CfBDqmSCWUprHFQDzCzt5eZ6w='
WHERE
key_id = '302c72bc348e7024de31e1e254922a5a2b1848a6cc679e4ce11402debdaa603f'
AND (
token = 'iMv92wDf6SAMZ62WC7CfBDqmSCWUprHFQDzCzt5eZ6w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)